Oracle SQLs: Get system date; count user tables. etc,.

Categories: Database; Tagged with: Oracle • Select system date; @ October 22nd, 2011 19:32

Get system date

select to_char(sysdate, 'yyyy-mm-dd hh24:mi:ss') from dual; -- Get the formatted system date.
select sysdate from dual; -- Get date

Count user tables:

SELECT OWNER,COUNT(*) FROM ALL_TABLES GROUP BY OWNER;  -- List all user and table number they own;

select count(*) from dba_tables t where t.owner='NAME'; -- Count tables of user with the name of "NAME"
select count(table_name) from user_tables; -- Count tables of current user;

注册Kindle/Kindle Touch,通过邮件Push书籍,并使用Kindle Personal Documents Service查看/下载/转发已发送的文件 <-> AIR Error: invalid application descriptor: Unknown namespace/ versionNumber must have a non-empty value.